課程資訊
課程名稱
資料庫系統-從SQL到NoSQL
Database Management System – from SQL to NoSQL 
開課學期
106-2 
授課對象
電機資訊學院  電機工程學研究所  
授課教師
駱明凌 
課號
EE5178 
課程識別碼
921 U2560 
班次
 
學分
3.0 
全/半年
半年 
必/選修
選修 
上課時間
星期四7,8,9(14:20~17:20) 
上課地點
電二145 
備註
總人數上限:80人 
Ceiba 課程網頁
http://ceiba.ntu.edu.tw/1062EE5178_1 
課程簡介影片
 
核心能力關聯
本課程尚未建立核心能力關連
課程大綱
為確保您我的權利,請尊重智慧財產權及不得非法影印
課程概述

Database processing and database management systems (DBMS) have been a corner stone of modern society. In science, engineering, business and enterprise alike, data play a central role in their progress. With recent developments in the fields of big data, machine learning, social network, and Internet of Things, to name a few, increases in data volume and manifestations of new data patterns have made the study of database both more interesting and more challenging. In this course, we cover the theory and practice of database management systems. We discuss the modeling, programming, management, architecture and implementation aspects of DBMS, study the evolution from well-established relational SQL databases to the new NoSQL databases, and cover the newest trends in database research brought about by the challenges of the big data trends.

 

課程目標
1. Acquire basic knowledge and concepts about databases and database management systems (DBMS)
2. Obtain basic capabilities to program for databases, and basic capabilities to operate DBMS
3. Learn the design thinking and rationales behind various database technologies -- hope one day to use these design reasoning skills in real-life designs
4. Learn the design thinking and rationales for large (often distributed) software systems
 
課程要求
Understanding of programming languages, capability to use a programming language (at least one of C/C++, Java, Python)
Understanding of data structures (List, tree, hash table, etc.)
Familiarity in the use of computer (PC)
Ability to search for and utilize resources online


 
預期每週課後學習時數
 
Office Hours
 
指定閱讀
NULL 
參考書目
參考書目:
Fundamentals of Database Systems (6th Edition)
by Ramez Elmasri (Author),‎ Shamkant B. Navathe (Author)
Database Management Systems, 3rd Edition
by Raghu Ramakrishnan (Author),‎ Johannes Gehrke (Author) 
評量方式
(僅供參考)
 
No.
項目
百分比
說明
1. 
Course work 
50% 
作業 
2. 
Mid term 
20% 
期中考 
3. 
Final project 
30% 
期末專題 
 
課程進度
週次
日期
單元主題
第1週
3/01  Introduction 
第2週
3/08  Conceptual Modeling - ER Model 
第3週
3/15  Data models - Relational database model 
第4週
3/22  Data models - Relational database model 
第5週
3/29  Basic SQL 
第6週
4/05  National holiday 
第7週
4/12  Relational Algebra and Advanced SQL  
第8週
4/19  Data models - legacy and new 
第9週
4/26  Data models - new;
Interfacing with programming languages 
第10週
5/03  Implementation and architecture topics 
第11週
5/10  Query optimization and normalization techniques 
第12週
5/17  Midterm examination 
第13週
5/24  Advanced database topics I 
第14週
5/31  Advanced database topics II & Transaction processing and concurrency control 
第15週
6/07  Advanced database topics III 
第16週
6/14  Final project presentation 
第17週
6/21  Final project presentation